package com.fengxing.ams.web.facade.mouble.luqu;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.data.repository.query.Param;

public interface ILuQuDAO extends PagingAndSortingRepository<LuQuVO, String>, JpaSpecificationExecutor<LuQuVO>  {

	@Query("select t from LuQuVO t where t.year = :year and t.zongfen > :maxScore and t.zongfen < :minScore and t.type = :type and t.batch = :batch and t.plan = :plan and t.enroll = :enroll and t.school like %:school% and t.major like %:major%")
	List<LuQuVO> queryByTime(@Param("year")Integer year, @Param("maxScore")Double maxScore,  @Param("minScore")Double minScore, @Param("type")Integer type,
			@Param("batch")String batch, @Param("plan")String plan, @Param("enroll")String enroll, @Param("school")String school,
			@Param("major")String major);
	
}
